/*
 * Copyright 2010 bedatadriven
 *
 *    Licensed under the Apache License, Version 2.0 (the "License");
 *    you may not use this file except in compliance with the License.
 *    You may obtain a copy of the License at
 *
 *        http://www.apache.org/licenses/LICENSE-2.0
 *
 *    Unless required by applicable law or agreed to in writing, software
 *    distributed under the License is distributed on an "AS IS" BASIS,
 *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *    See the License for the specific language governing permissions and
 *    limitations under the License.
 */

/**
 * JacobGen generated file --- do not edit
 *
 * (http://www.bigatti.it/projects/jacobgen)
 */
package com.bedatadriven.mso.excel;

import com.bedatadriven.mso.core.MsoEnvelope;
import com.bedatadriven.mso.core.Scripts;
import com.google.gwt.core.client.JavaScriptObject;

/** Wrapper for Excel.Worksheet*/
public class Worksheet extends JavaScriptObject {

	protected Worksheet() { }

  public native final ExcelApplication getApplication()/*-{
    return this.Application;
  }-*/;

  public native final int getCreator()/*-{
    return this.Creator;
  }-*/;

  public native final Object getParent()/*-{
    return this.Parent;
  }-*/;

  public native final void activate()/*-{
    this.Activate( );
  }-*/;

  public native final void copy( Object before,  Object after)/*-{
    this.Copy( before, after);
  }-*/;

  public native final void delete()/*-{
    this.Delete( );
  }-*/;

  public native final String getCodeName()/*-{
    return this.CodeName;
  }-*/;

  public native final String get_CodeName()/*-{
    return this._CodeName;
  }-*/;

  public native final void set_CodeName(String value)/*-{
    this._CodeName = value;
  }-*/;

  public native final int getIndex()/*-{
    return this.Index;
  }-*/;

  public native final void move( Object before,  Object after)/*-{
    this.Move( before, after);
  }-*/;

  public native final String getName()/*-{
    return this.Name;
  }-*/;

  public native final void setName(String value)/*-{
    this.Name = value;
  }-*/;

  public native final Object getNext()/*-{
    return this.Next;
  }-*/;

  public native final String getOnDoubleClick()/*-{
    return this.OnDoubleClick;
  }-*/;

  public native final void setOnDoubleClick(String value)/*-{
    this.OnDoubleClick = value;
  }-*/;

  public native final String getOnSheetActivate()/*-{
    return this.OnSheetActivate;
  }-*/;

  public native final void setOnSheetActivate(String value)/*-{
    this.OnSheetActivate = value;
  }-*/;

  public native final String getOnSheetDeactivate()/*-{
    return this.OnSheetDeactivate;
  }-*/;

  public native final void setOnSheetDeactivate(String value)/*-{
    this.OnSheetDeactivate = value;
  }-*/;

  public native final PageSetup getPageSetup()/*-{
    return this.PageSetup;
  }-*/;

  public native final Object getPrevious()/*-{
    return this.Previous;
  }-*/;

  public native final void __PrintOut( Object from,  Object to,  Object copies,  Object preview,  Object activePrinter,  Object printToFile,  Object collate)/*-{
    this.__PrintOut( from, to, copies, preview, activePrinter, printToFile, collate);
  }-*/;

  public native final void printPreview( Object enableChanges)/*-{
    this.PrintPreview( enableChanges);
  }-*/;

  public native final void _Protect( Object password,  Object drawingObjects,  Object contents,  Object scenarios,  Object userInterfaceOnly)/*-{
    this._Protect( password, drawingObjects, contents, scenarios, userInterfaceOnly);
  }-*/;

  public native final boolean getProtectContents()/*-{
    return this.ProtectContents;
  }-*/;

  public native final boolean getProtectDrawingObjects()/*-{
    return this.ProtectDrawingObjects;
  }-*/;

  public native final boolean getProtectionMode()/*-{
    return this.ProtectionMode;
  }-*/;

  public native final boolean getProtectScenarios()/*-{
    return this.ProtectScenarios;
  }-*/;

  public native final void _SaveAs(String filename,  Object fileFormat,  Object password,  Object writeResPassword,  Object readOnlyRecommended,  Object createBackup,  Object addToMru,  Object textCodepage,  Object textVisualLayout)/*-{
    this._SaveAs( filename, fileFormat, password, writeResPassword, readOnlyRecommended, createBackup, addToMru, textCodepage, textVisualLayout);
  }-*/;

  public native final void select( Object replace)/*-{
    this.Select( replace);
  }-*/;

  public native final void unprotect( Object password)/*-{
    this.Unprotect( password);
  }-*/;

  public native final int getVisible()/*-{
    return this.Visible;
  }-*/;

  public native final void setVisible(int value)/*-{
    this.Visible = value;
  }-*/;

  public native final Shapes getShapes()/*-{
    return this.Shapes;
  }-*/;

  public native final boolean getTransitionExpEval()/*-{
    return this.TransitionExpEval;
  }-*/;

  public native final void setTransitionExpEval(boolean value)/*-{
    this.TransitionExpEval = value;
  }-*/;

  public native final Object arcs( Object index)/*-{
    return this.Arcs( index);
  }-*/;

  public native final boolean getAutoFilterMode()/*-{
    return this.AutoFilterMode;
  }-*/;

  public native final void setAutoFilterMode(boolean value)/*-{
    this.AutoFilterMode = value;
  }-*/;

  public native final void setBackgroundPicture(String filename)/*-{
    this.SetBackgroundPicture( filename);
  }-*/;

  public native final Object buttons( Object index)/*-{
    return this.Buttons( index);
  }-*/;

  public native final void calculate()/*-{
    this.Calculate( );
  }-*/;

  public native final boolean getEnableCalculation()/*-{
    return this.EnableCalculation;
  }-*/;

  public native final void setEnableCalculation(boolean value)/*-{
    this.EnableCalculation = value;
  }-*/;

  public native final Range getCells()/*-{
    return this.Cells;
  }-*/;

  public native final Object chartObjects( Object index)/*-{
    return this.ChartObjects( index);
  }-*/;

  public native final Object checkBoxes( Object index)/*-{
    return this.CheckBoxes( index);
  }-*/;

  public native final void checkSpelling( Object customDictionary,  Object ignoreUppercase,  Object alwaysSuggest,  Object spellLang)/*-{
    this.CheckSpelling( customDictionary, ignoreUppercase, alwaysSuggest, spellLang);
  }-*/;

  public native final Range getCircularReference()/*-{
    return this.CircularReference;
  }-*/;

  public native final void clearArrows()/*-{
    this.ClearArrows( );
  }-*/;

  public native final Range getColumns()/*-{
    return this.Columns;
  }-*/;

  public native final int getConsolidationFunction()/*-{
    return this.ConsolidationFunction;
  }-*/;

  public native final JavaScriptObject getConsolidationOptions()/*-{
    return this.ConsolidationOptions;
  }-*/;

  public native final JavaScriptObject getConsolidationSources()/*-{
    return this.ConsolidationSources;
  }-*/;

  public native final boolean getDisplayAutomaticPageBreaks()/*-{
    return this.DisplayAutomaticPageBreaks;
  }-*/;

  public native final void setDisplayAutomaticPageBreaks(boolean value)/*-{
    this.DisplayAutomaticPageBreaks = value;
  }-*/;

  public native final Object drawings( Object index)/*-{
    return this.Drawings( index);
  }-*/;

  public native final Object drawingObjects( Object index)/*-{
    return this.DrawingObjects( index);
  }-*/;

  public native final Object dropDowns( Object index)/*-{
    return this.DropDowns( index);
  }-*/;

  public native final boolean getEnableAutoFilter()/*-{
    return this.EnableAutoFilter;
  }-*/;

  public native final void setEnableAutoFilter(boolean value)/*-{
    this.EnableAutoFilter = value;
  }-*/;

  public native final int getEnableSelection()/*-{
    return this.EnableSelection;
  }-*/;

  public native final void setEnableSelection(int value)/*-{
    this.EnableSelection = value;
  }-*/;

  public native final boolean getEnableOutlining()/*-{
    return this.EnableOutlining;
  }-*/;

  public native final void setEnableOutlining(boolean value)/*-{
    this.EnableOutlining = value;
  }-*/;

  public native final boolean getEnablePivotTable()/*-{
    return this.EnablePivotTable;
  }-*/;

  public native final void setEnablePivotTable(boolean value)/*-{
    this.EnablePivotTable = value;
  }-*/;

  public native final JavaScriptObject evaluate( Object name)/*-{
    return this.Evaluate( name);
  }-*/;

  public native final JavaScriptObject _Evaluate( Object name)/*-{
    return this._Evaluate( name);
  }-*/;

  public native final boolean getFilterMode()/*-{
    return this.FilterMode;
  }-*/;

  public native final void resetAllPageBreaks()/*-{
    this.ResetAllPageBreaks( );
  }-*/;

  public native final Object groupBoxes( Object index)/*-{
    return this.GroupBoxes( index);
  }-*/;

  public native final Object groupObjects( Object index)/*-{
    return this.GroupObjects( index);
  }-*/;

  public native final Object labels( Object index)/*-{
    return this.Labels( index);
  }-*/;

  public native final Object lines( Object index)/*-{
    return this.Lines( index);
  }-*/;

  public native final Object listBoxes( Object index)/*-{
    return this.ListBoxes( index);
  }-*/;

  public native final Names getNames()/*-{
    return this.Names;
  }-*/;

  public native final Object oLEObjects( Object index)/*-{
    return this.OLEObjects( index);
  }-*/;

  public native final String getOnCalculate()/*-{
    return this.OnCalculate;
  }-*/;

  public native final void setOnCalculate(String value)/*-{
    this.OnCalculate = value;
  }-*/;

  public native final String getOnData()/*-{
    return this.OnData;
  }-*/;

  public native final void setOnData(String value)/*-{
    this.OnData = value;
  }-*/;

  public native final String getOnEntry()/*-{
    return this.OnEntry;
  }-*/;

  public native final void setOnEntry(String value)/*-{
    this.OnEntry = value;
  }-*/;

  public native final Object optionButtons( Object index)/*-{
    return this.OptionButtons( index);
  }-*/;

  public native final Outline getOutline()/*-{
    return this.Outline;
  }-*/;

  public native final Object ovals( Object index)/*-{
    return this.Ovals( index);
  }-*/;

  public native final void paste( Object destination,  Object link)/*-{
    this.Paste( destination, link);
  }-*/;

  public native final void _PasteSpecial( Object format,  Object link,  Object displayAsIcon,  Object iconFileName,  Object iconIndex,  Object iconLabel)/*-{
    this._PasteSpecial( format, link, displayAsIcon, iconFileName, iconIndex, iconLabel);
  }-*/;

  public native final Object pictures( Object index)/*-{
    return this.Pictures( index);
  }-*/;

  public native final Object pivotTables( Object index)/*-{
    return this.PivotTables( index);
  }-*/;

  public native final PivotTable pivotTableWizard( Object sourceType,  Object sourceData,  Object tableDestination,  Object tableName,  Object rowGrand,  Object columnGrand,  Object saveData,  Object hasAutoFormat,  Object autoPage,  Object reserved,  Object backgroundQuery,  Object optimizeCache,  Object pageFieldOrder,  Object pageFieldWrapCount,  Object readData,  Object connection)/*-{
    return this.PivotTableWizard( sourceType, sourceData, tableDestination, tableName, rowGrand, columnGrand, saveData, hasAutoFormat, autoPage, reserved, backgroundQuery, optimizeCache, pageFieldOrder, pageFieldWrapCount, readData, connection);
  }-*/;


  public final Range getRange(CellAddress address) {
    assert address != null : "at least one address must be provided";
    return _getRange(address.toString(), null);
  }

  public final Range getRange(CellAddress fromCell, CellAddress toCell) {
    assert fromCell != null : "at least one address must be provided";
    return _getRange(fromCell.toString(), toCell.toString());
  }

  private native final Range _getRange( Object cell1,  Object cell2) /*-{
    return this.Range(cell1, cell2);
  }-*/;

  public native final Object rectangles( Object index)/*-{
    return this.Rectangles( index);
  }-*/;

  public native final Range getRows()/*-{
    return this.Rows;
  }-*/;

  public native final Object scenarios( Object index)/*-{
    return this.Scenarios( index);
  }-*/;

  public native final String getScrollArea()/*-{
    return this.ScrollArea;
  }-*/;

  public native final void setScrollArea(String value)/*-{
    this.ScrollArea = value;
  }-*/;

  public native final Object scrollBars( Object index)/*-{
    return this.ScrollBars( index);
  }-*/;

  public native final void showAllData()/*-{
    this.ShowAllData( );
  }-*/;

  public native final void showDataForm()/*-{
    this.ShowDataForm( );
  }-*/;

  public native final Object spinners( Object index)/*-{
    return this.Spinners( index);
  }-*/;

  public native final double getStandardHeight()/*-{
    return this.StandardHeight;
  }-*/;

  public native final double getStandardWidth()/*-{
    return this.StandardWidth;
  }-*/;

  public native final void setStandardWidth(double value)/*-{
    this.StandardWidth = value;
  }-*/;

  public native final Object textBoxes( Object index)/*-{
    return this.TextBoxes( index);
  }-*/;

  public native final boolean getTransitionFormEntry()/*-{
    return this.TransitionFormEntry;
  }-*/;

  public native final void setTransitionFormEntry(boolean value)/*-{
    this.TransitionFormEntry = value;
  }-*/;

  public native final int getType()/*-{
    return this.Type;
  }-*/;

  public native final Range getUsedRange()/*-{
    return this.UsedRange;
  }-*/;

  public native final HPageBreaks getHPageBreaks()/*-{
    return this.HPageBreaks;
  }-*/;

  public native final VPageBreaks getVPageBreaks()/*-{
    return this.VPageBreaks;
  }-*/;

  public native final QueryTables getQueryTables()/*-{
    return this.QueryTables;
  }-*/;

  public native final boolean getDisplayPageBreaks()/*-{
    return this.DisplayPageBreaks;
  }-*/;

  public native final void setDisplayPageBreaks(boolean value)/*-{
    this.DisplayPageBreaks = value;
  }-*/;

  public native final Comments getComments()/*-{
    return this.Comments;
  }-*/;

  public native final Hyperlinks getHyperlinks()/*-{
    return this.Hyperlinks;
  }-*/;

  public native final void clearCircles()/*-{
    this.ClearCircles( );
  }-*/;

  public native final void circleInvalid()/*-{
    this.CircleInvalid( );
  }-*/;

  public native final int get_DisplayRightToLeft()/*-{
    return this._DisplayRightToLeft;
  }-*/;

  public native final void set_DisplayRightToLeft(int value)/*-{
    this._DisplayRightToLeft = value;
  }-*/;

  public native final AutoFilter getAutoFilter()/*-{
    return this.AutoFilter;
  }-*/;

  public native final boolean getDisplayRightToLeft()/*-{
    return this.DisplayRightToLeft;
  }-*/;

  public native final void setDisplayRightToLeft(boolean value)/*-{
    this.DisplayRightToLeft = value;
  }-*/;

  public native final Scripts getScripts()/*-{
    return this.Scripts;
  }-*/;

  public native final void _PrintOut( Object from,  Object to,  Object copies,  Object preview,  Object activePrinter,  Object printToFile,  Object collate,  Object prToFileName)/*-{
    this._PrintOut( from, to, copies, preview, activePrinter, printToFile, collate, prToFileName);
  }-*/;

  public native final void _CheckSpelling( Object customDictionary,  Object ignoreUppercase,  Object alwaysSuggest,  Object spellLang,  Object ignoreFinalYaa,  Object spellScript)/*-{
    this._CheckSpelling( customDictionary, ignoreUppercase, alwaysSuggest, spellLang, ignoreFinalYaa, spellScript);
  }-*/;

  public native final Tab getTab()/*-{
    return this.Tab;
  }-*/;

  public native final MsoEnvelope getMailEnvelope()/*-{
    return this.MailEnvelope;
  }-*/;

  public native final void saveAs(String filename,  Object fileFormat,  Object password,  Object writeResPassword,  Object readOnlyRecommended,  Object createBackup,  Object addToMru,  Object textCodepage,  Object textVisualLayout,  Object local)/*-{
    this.SaveAs( filename, fileFormat, password, writeResPassword, readOnlyRecommended, createBackup, addToMru, textCodepage, textVisualLayout, local);
  }-*/;

  public native final CustomProperties getCustomProperties()/*-{
    return this.CustomProperties;
  }-*/;

  public native final SmartTags getSmartTags()/*-{
    return this.SmartTags;
  }-*/;

  public native final Protection getProtection()/*-{
    return this.Protection;
  }-*/;

  public native final void pasteSpecial( Object format,  Object link,  Object displayAsIcon,  Object iconFileName,  Object iconIndex,  Object iconLabel,  Object noHTMLFormatting)/*-{
    this.PasteSpecial( format, link, displayAsIcon, iconFileName, iconIndex, iconLabel, noHTMLFormatting);
  }-*/;

  public native final void protect( Object password,  Object drawingObjects,  Object contents,  Object scenarios,  Object userInterfaceOnly,  Object allowFormattingCells,  Object allowFormattingColumns,  Object allowFormattingRows,  Object allowInsertingColumns,  Object allowInsertingRows,  Object allowInsertingHyperlinks,  Object allowDeletingColumns,  Object allowDeletingRows,  Object allowSorting,  Object allowFiltering,  Object allowUsingPivotTables)/*-{
    this.Protect( password, drawingObjects, contents, scenarios, userInterfaceOnly, allowFormattingCells, allowFormattingColumns, allowFormattingRows, allowInsertingColumns, allowInsertingRows, allowInsertingHyperlinks, allowDeletingColumns, allowDeletingRows, allowSorting, allowFiltering, allowUsingPivotTables);
  }-*/;

  public native final ListObjects getListObjects()/*-{
    return this.ListObjects;
  }-*/;

  public native final Range xmlDataQuery(String xPath,  Object selectionNamespaces,  Object map)/*-{
    return this.XmlDataQuery( xPath, selectionNamespaces, map);
  }-*/;

  public native final Range xmlMapQuery(String xPath,  Object selectionNamespaces,  Object map)/*-{
    return this.XmlMapQuery( xPath, selectionNamespaces, map);
  }-*/;

  public native final void printOut( Object from,  Object to,  Object copies,  Object preview,  Object activePrinter,  Object printToFile,  Object collate,  Object prToFileName,  Object ignorePrintAreas)/*-{
    this.PrintOut( from, to, copies, preview, activePrinter, printToFile, collate, prToFileName, ignorePrintAreas);
  }-*/;

  public native final boolean getEnableFormatConditionsCalculation()/*-{
    return this.EnableFormatConditionsCalculation;
  }-*/;

  public native final void setEnableFormatConditionsCalculation(boolean value)/*-{
    this.EnableFormatConditionsCalculation = value;
  }-*/;

  public native final Sort getSort()/*-{
    return this.Sort;
  }-*/;

  public native final void exportAsFixedFormat(int type,  Object filename,  Object quality,  Object includeDocProperties,  Object ignorePrintAreas,  Object from,  Object to,  Object openAfterPublish,  Object fixedFormatExtClassPtr)/*-{
    this.ExportAsFixedFormat( type, filename, quality, includeDocProperties, ignorePrintAreas, from, to, openAfterPublish, fixedFormatExtClassPtr);
  }-*/;

}
